create or replace
TRIGGER RANGED_WEAPON_TRIGGER
BEFORE INSERT ON RANGED_WEAPONS
FOR EACH ROW WHEN (NEW.RANGED_WEAPON_ID IS NULL)
BEGIN 
	SELECT RANGED_WEAPONS_SEQ.NEXTVAL 
	INTO :NEW.RANGED_WEAPON_ID 
	FROM DUAL;
END;